-- 2012-05-17 EM .

alter procedure sp_make_info
	@state varchar(20),
	@code varchar(20),
	@desc varchar(200),
	@xml xml output
as
begin
	set nocount on;
	exec sms_p.dbo.prints '$$$ 000',@State, @Desc,32		
	set @xml = '<info state="'+ @state +'" code="'+ @code +'" desc="'+ @desc +'" />';
end;
go

grant execute on sp_make_info to Executer;